using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
   public partial class VKPGAR
    {
      #region======ColumnSchema==========
       /*
                public string KPGMANDANT { get { if (dwMaster == null) return ""; return dwMaster["KPGMANDANT"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGMANDANT"] = value; OnPropertyChanged("KPGMANDANT", value); } } //lENGth 2
                public string KPGKUNDNR { get { if (dwMaster == null) return ""; return dwMaster["KPGKUNDNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGKUNDNR"] = value; OnPropertyChanged("KPGKUNDNR", value); } } //lENGth 8
                public string KPGAKKREDNR { get { if (dwMaster == null) return ""; return dwMaster["KPGAKKREDNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGAKKREDNR"] = value; OnPropertyChanged("KPGAKKREDNR", value); } } //lENGth 20
                public string KPGCLOSED { get { if (dwMaster == null) return ""; return dwMaster["KPGCLOSED"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGCLOSED"] = value; OnPropertyChanged("KPGCLOSED", value); } } //lENGth 1
                public string KPGEKON { get { if (dwMaster == null) return ""; return dwMaster["KPGEKON"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGEKON"] = value; OnPropertyChanged("KPGEKON", value); } } //lENGth 8
                public string KPGBIC { get { if (dwMaster == null) return ""; return dwMaster["KPGBIC"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGBIC"] = value; OnPropertyChanged("KPGBIC", value); } } //lENGth 11
                public string KPGGBIC { get { if (dwMaster == null) return ""; return dwMaster["KPGGBIC"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGGBIC"] = value; OnPropertyChanged("KPGGBIC", value); } } //lENGth 11
                public string KPGGIBAN { get { if (dwMaster == null) return ""; return dwMaster["KPGGIBAN"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGGIBAN"] = value; OnPropertyChanged("KPGGIBAN", value); } } //lENGth 34
                public string KPGGARANTYP { get { if (dwMaster == null) return ""; return dwMaster["KPGGARANTYP"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGGARANTYP"] = value; OnPropertyChanged("KPGGARANTYP", value); } } //lENGth 1
                public double KPGGUELTVON { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["KPGGUELTVON"].ToString()); } set { if (dwMaster == null) return; dwMaster["KPGGUELTVON"] = value; OnPropertyChanged("KPGGUELTVON", value); } } //lENGth 0
                public double KPGGUELTBIS { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["KPGGUELTBIS"].ToString()); } set { if (dwMaster == null) return; dwMaster["KPGGUELTBIS"] = value; OnPropertyChanged("KPGGUELTBIS", value); } } //lENGth 0
                public double KPGLIEFVON { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["KPGLIEFVON"].ToString()); } set { if (dwMaster == null) return; dwMaster["KPGLIEFVON"] = value; OnPropertyChanged("KPGLIEFVON", value); } } //lENGth 0
                public double KPGLIEFBIS { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["KPGLIEFBIS"].ToString()); } set { if (dwMaster == null) return; dwMaster["KPGLIEFBIS"] = value; OnPropertyChanged("KPGLIEFBIS", value); } } //lENGth 0
                public string KPGBETRAG { get { if (dwMaster == null) return ""; return dwMaster["KPGBETRAG"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGBETRAG"] = value; OnPropertyChanged("KPGBETRAG", value); } } //lENGth 11
                public string KPGWAEHRSL { get { if (dwMaster == null) return ""; return dwMaster["KPGWAEHRSL"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGWAEHRSL"] = value; OnPropertyChanged("KPGWAEHRSL", value); } } //lENGth 3
                public double KPGPROZPLU { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["KPGPROZPLU"].ToString()); } set { if (dwMaster == null) return; dwMaster["KPGPROZPLU"] = value; OnPropertyChanged("KPGPROZPLU", value); } } //lENGth 0
                public double KPGPROZMIN { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["KPGPROZMIN"].ToString()); } set { if (dwMaster == null) return; dwMaster["KPGPROZMIN"] = value; OnPropertyChanged("KPGPROZMIN", value); } } //lENGth 0
                public string KPGTEILVERL { get { if (dwMaster == null) return ""; return dwMaster["KPGTEILVERL"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGTEILVERL"] = value; OnPropertyChanged("KPGTEILVERL", value); } } //lENGth 1
                public string KPGLIEFBED { get { if (dwMaster == null) return ""; return dwMaster["KPGLIEFBED"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGLIEFBED"] = value; OnPropertyChanged("KPGLIEFBED", value); } } //lENGth 3
                public string KPGZLAND { get { if (dwMaster == null) return ""; return dwMaster["KPGZLAND"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGZLAND"] = value; OnPropertyChanged("KPGZLAND", value); } } //lENGth 3
                public string KPGZPLZ { get { if (dwMaster == null) return ""; return dwMaster["KPGZPLZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGZPLZ"] = value; OnPropertyChanged("KPGZPLZ", value); } } //lENGth 12
                public string KPGZORT { get { if (dwMaster == null) return ""; return dwMaster["KPGZORT"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGZORT"] = value; OnPropertyChanged("KPGZORT", value); } } //lENGth 40
                public string KPGSNAME1 { get { if (dwMaster == null) return ""; return dwMaster["KPGSNAME1"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGSNAME1"] = value; OnPropertyChanged("KPGSNAME1", value); } } //lENGth 40
                public string KPGSNAME2 { get { if (dwMaster == null) return ""; return dwMaster["KPGSNAME2"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGSNAME2"] = value; OnPropertyChanged("KPGSNAME2", value); } } //lENGth 40
                public string KPGSZUSATZ { get { if (dwMaster == null) return ""; return dwMaster["KPGSZUSATZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGSZUSATZ"] = value; OnPropertyChanged("KPGSZUSATZ", value); } } //lENGth 40
                public string KPGSSTRASSE { get { if (dwMaster == null) return ""; return dwMaster["KPGSSTRASSE"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGSSTRASSE"] = value; OnPropertyChanged("KPGSSTRASSE", value); } } //lENGth 40
                public string KPGSLAND { get { if (dwMaster == null) return ""; return dwMaster["KPGSLAND"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGSLAND"] = value; OnPropertyChanged("KPGSLAND", value); } } //lENGth 3
                public string KPGSPLZ { get { if (dwMaster == null) return ""; return dwMaster["KPGSPLZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGSPLZ"] = value; OnPropertyChanged("KPGSPLZ", value); } } //lENGth 12
                public string KPGSORT { get { if (dwMaster == null) return ""; return dwMaster["KPGSORT"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGSORT"] = value; OnPropertyChanged("KPGSORT", value); } } //lENGth 40
                public string KPGBNAME1 { get { if (dwMaster == null) return ""; return dwMaster["KPGBNAME1"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGBNAME1"] = value; OnPropertyChanged("KPGBNAME1", value); } } //lENGth 40
                public string KPGBNAME2 { get { if (dwMaster == null) return ""; return dwMaster["KPGBNAME2"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGBNAME2"] = value; OnPropertyChanged("KPGBNAME2", value); } } //lENGth 40
                public string KPGBZUSATZ { get { if (dwMaster == null) return ""; return dwMaster["KPGBZUSATZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGBZUSATZ"] = value; OnPropertyChanged("KPGBZUSATZ", value); } } //lENGth 40
                public string KPGBSTRASSE { get { if (dwMaster == null) return ""; return dwMaster["KPGBSTRASSE"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGBSTRASSE"] = value; OnPropertyChanged("KPGBSTRASSE", value); } } //lENGth 40
                public string KPGBLAND { get { if (dwMaster == null) return ""; return dwMaster["KPGBLAND"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGBLAND"] = value; OnPropertyChanged("KPGBLAND", value); } } //lENGth 3
                public string KPGBPLZ { get { if (dwMaster == null) return ""; return dwMaster["KPGBPLZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGBPLZ"] = value; OnPropertyChanged("KPGBPLZ", value); } } //lENGth 12
                public string KPGBORT { get { if (dwMaster == null) return ""; return dwMaster["KPGBORT"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGBORT"] = value; OnPropertyChanged("KPGBORT", value); } } //lENGth 40
                public string KPGDOCTYP1 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCTYP1"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCTYP1"] = value; OnPropertyChanged("KPGDOCTYP1", value); } } //lENGth 1
                public string KPGDOCANZ1 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCANZ1"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCANZ1"] = value; OnPropertyChanged("KPGDOCANZ1", value); } } //lENGth 2
                public string KPGDOCTYP2 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCTYP2"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCTYP2"] = value; OnPropertyChanged("KPGDOCTYP2", value); } } //lENGth 1
                public string KPGDOCANZ2 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCANZ2"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCANZ2"] = value; OnPropertyChanged("KPGDOCANZ2", value); } } //lENGth 2
                public string KPGDOCTYP3 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCTYP3"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCTYP3"] = value; OnPropertyChanged("KPGDOCTYP3", value); } } //lENGth 1
                public string KPGDOCANZ3 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCANZ3"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCANZ3"] = value; OnPropertyChanged("KPGDOCANZ3", value); } } //lENGth 2
                public string KPGDOCTYP4 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCTYP4"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCTYP4"] = value; OnPropertyChanged("KPGDOCTYP4", value); } } //lENGth 1
                public string KPGDOCANZ4 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCANZ4"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCANZ4"] = value; OnPropertyChanged("KPGDOCANZ4", value); } } //lENGth 2
                public string KPGDOCTYP5 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCTYP5"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCTYP5"] = value; OnPropertyChanged("KPGDOCTYP5", value); } } //lENGth 1
                public string KPGDOCANZ5 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCANZ5"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCANZ5"] = value; OnPropertyChanged("KPGDOCANZ5", value); } } //lENGth 2
                public string KPGDOCTYP6 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCTYP6"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCTYP6"] = value; OnPropertyChanged("KPGDOCTYP6", value); } } //lENGth 1
                public string KPGDOCANZ6 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCANZ6"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCANZ6"] = value; OnPropertyChanged("KPGDOCANZ6", value); } } //lENGth 2
                public string KPGDOCTYP7 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCTYP7"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCTYP7"] = value; OnPropertyChanged("KPGDOCTYP7", value); } } //lENGth 1
                public string KPGDOCANZ7 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCANZ7"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCANZ7"] = value; OnPropertyChanged("KPGDOCANZ7", value); } } //lENGth 2
                public string KPGDOCTYP8 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCTYP8"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCTYP8"] = value; OnPropertyChanged("KPGDOCTYP8", value); } } //lENGth 1
                public string KPGDOCANZ8 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCANZ8"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCANZ8"] = value; OnPropertyChanged("KPGDOCANZ8", value); } } //lENGth 2
                public string KPGDOCTYP9 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCTYP9"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCTYP9"] = value; OnPropertyChanged("KPGDOCTYP9", value); } } //lENGth 1
                public string KPGDOCANZ9 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCANZ9"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCANZ9"] = value; OnPropertyChanged("KPGDOCANZ9", value); } } //lENGth 2
                public string KPGDOCTYP10 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCTYP10"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCTYP10"] = value; OnPropertyChanged("KPGDOCTYP10", value); } } //lENGth 1
                public string KPGDOCANZ10 { get { if (dwMaster == null) return ""; return dwMaster["KPGDOCANZ10"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGDOCANZ10"] = value; OnPropertyChanged("KPGDOCANZ10", value); } } //lENGth 2
                public double KPGWVTERM { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["KPGWVTERM"].ToString()); } set { if (dwMaster == null) return; dwMaster["KPGWVTERM"] = value; OnPropertyChanged("KPGWVTERM", value); } } //lENGth 0
                public string KPGGENEHM { get { if (dwMaster == null) return ""; return dwMaster["KPGGENEHM"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGGENEHM"] = value; OnPropertyChanged("KPGGENEHM", value); } } //lENGth 1
                public string KPGFAKT { get { if (dwMaster == null) return ""; return dwMaster["KPGFAKT"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGFAKT"] = value; OnPropertyChanged("KPGFAKT", value); } } //lENGth 11
                public string KPGFREIG { get { if (dwMaster == null) return ""; return dwMaster["KPGFREIG"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGFREIG"] = value; OnPropertyChanged("KPGFREIG", value); } } //lENGth 11
                public string KPGFILLER { get { if (dwMaster == null) return ""; return dwMaster["KPGFILLER"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGFILLER"] = value; OnPropertyChanged("KPGFILLER", value); } } //lENGth 48
                public double KPGAENZL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["KPGAENZL"].ToString()); } set { if (dwMaster == null) return; dwMaster["KPGAENZL"] = value; OnPropertyChanged("KPGAENZL", value); } } //lENGth 0
                public string KPGAENB { get { if (dwMaster == null) return ""; return dwMaster["KPGAENB"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGAENB"] = value; OnPropertyChanged("KPGAENB", value); } } //lENGth 8
                public double KPGAEND { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["KPGAEND"].ToString()); } set { if (dwMaster == null) return; dwMaster["KPGAEND"] = value; OnPropertyChanged("KPGAEND", value); } } //lENGth 0
                public string KPGNEUB { get { if (dwMaster == null) return ""; return dwMaster["KPGNEUB"].ToString(); } set { if (dwMaster == null) return; dwMaster["KPGNEUB"] = value; OnPropertyChanged("KPGNEUB", value); } } //lENGth 8
                public double KPGNEUD { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["KPGNEUD"].ToString()); } set { if (dwMaster == null) return; dwMaster["KPGNEUD"] = value; OnPropertyChanged("KPGNEUD", value); } } //lENGth 0
       */
       #endregion
    } 
}
